CREATE TABLE [EventType](
	eventTypeID int IDENTITY,
	description varchar(50) NOT NULL,
	PRIMARY KEY (eventTypeID)
)

CREATE TABLE [Event](
	eventID int IDENTITY,
	userID int NOT NULL,
	eventTypeID int NOT NULL,
	dateEnv date NOT NULL,
	timeEnv time NOT NULL,
	period varchar(50) NOT NULL,
	createdByUserName varchar(50) NOT NULL,
	status char(1) NOT NULL,
	PRIMARY KEY (eventID),
	FOREIGN KEY (userID) REFERENCES [User] (userID),
	FOREIGN KEY (eventTypeID) REFERENCES [EventType](eventTypeID)
)
